Create & Populate Staging Table for AIVideoAudioMetrics_Stg 7
1) Download attachment here
2) Open SQL File and run the script to create the Staging Table for the Staging Database (AIVideo_Staging) you created in the previous Step.
3) Create a Connection Manager for what will be two OLE DB Sources. The database to connect to will be CCPP. Test the connection.
Server Name: hypv8669.hostedbyappliedi.net
User Name: ColaberryDB
Password: Iam4Colaberry!
Create a Connection Manager for the Staging Database as well.
4) Follow the following GIF Instructions. FYI, you will need access to the aforementioned Colaberry server because it is where you will extract the data from; you will be merging these two tables for Staging: [dnnuser].[UVG_AIVideo] & [dnnuser].[UVG_AIVideo_Metrics].
When considering Data Conversion, you might need to leave the transcript text data as Unicode. This is the column designated for the transcribed words of the video and can contain over 5,000 characters.
12) Create an OLE DB Destination connected to the staging table within the AIVideo_Staging Database.
In SSMS ...